/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 18:06:04
*/


-- ----------------------------
-- Table structure for tb2536
-- ----------------------------
DROP TABLE [dbo].[tb2536]
GO
CREATE TABLE [dbo].[tb2536] (
[DutyID] varchar(20) NOT NULL ,
[DutyName] nvarchar(50) NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0)) ,
[CreateUserID] varchar(20) NOT NULL ,
[CreateDate] datetime NULL DEFAULT (getdate()) ,
[LastModifyUserID] varchar(20) NOT NULL ,
[LastModifyDate] datetime NULL DEFAULT (getdate()) ,
[DutyRate] smallmoney NULL 
)


GO

-- ----------------------------
-- Records of tb2536
-- ----------------------------
INSERT INTO [dbo].[tb2536] ([DutyID], [DutyName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate], [DutyRate]) VALUES (N'hhhhh', N'hhhhhhh', N'0', N'admin', N'2011-07-22 12:00:59.200', N'admin', N'2011-07-22 12:00:59.200', N'12.0000')
GO
GO
INSERT INTO [dbo].[tb2536] ([DutyID], [DutyName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate], [DutyRate]) VALUES (N'HHH', N'HH', N'0', N'admin', N'2011-07-22 12:00:39.357', N'admin', N'2011-07-22 12:00:39.357', N'.0000')
GO
GO
INSERT INTO [dbo].[tb2536] ([DutyID], [DutyName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate], [DutyRate]) VALUES (N'dfsdf', N'sdf', N'0', N'admin', N'2011-07-22 12:00:10.623', N'admin', N'2011-07-22 12:00:10.623', N'.0000')
GO
GO

-- ----------------------------
-- Indexes structure for table tb2536
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2536
-- ----------------------------
ALTER TABLE [dbo].[tb2536] ADD PRIMARY KEY NONCLUSTERED ([DutyID]) WITH (FILLFACTOR=90)
GO
